2013-04-29- 5956.200 - Rel Notes -ROC Enhancements - Ordering on Customer Segmentation. #DotNetReleases2013

Release Notes

5956.200 - Rel Notes -ROC Enhancements - Ordering on Customer Segmentation.

Admin Info

Purpose
 Ordering on Customer Segmentation.
Release No#
 001
Submitted on
 04/29/2012
Submitted by
 Rajesh S
Source/Destination Systems
 NEC DEV/NEC QA
Release Sent To
 Bibin Mohan
Objects Created By
 Rajesh S
Objects Tested By
 Satish K

Transport and Technical Objects

\\10.114.165.54\sites\Deployments\BMS ROCET RELEASES\
04292013_SQL
  • CreateOrder.aspx
  • ManageOrder.aspx
  • RocLogin.aspx
  • GenericClasses.cs
  • CustomerSegmentation.sql
  • Orders.cs

Release Notes

For Infrastructure


Please take backup of existing procedures and pages before moving dev->qa.

For Requestor

Following objects are updated

 Type
 Name
 Change
1
 Procedure
 USP_EDIT_CART
 Updated USP_EDIT_CART procedure.
2
 Procedure
 USP_DuplicateOrder
 Updated USP_DuplicateOrder procedure.
3
 Procedure
 usp_get_Searchresults
 Updated usp_get_Searchresults
procedure.
4
 Procedure
 USP_CompleteOrder
 Updated USP_CompleteOrder
procedure.
5
 Procedure
 USP_ProcessStubItems
 Updated USP_ProcessStubItems
procedure.
6
 Procedure
 USP_GET_Segments
 CreatedUSP_GET_Segments procedure.
7
 Procedure
 USP_GET_CUSTOMERS_SALESORG
 Created USP_GET_Segments procedure.
8
 Procedure
 Usp_DeleteInvalidMaterials
 Created Usp_DeleteInvalidMaterials
procedure.
9
 Procedure
 Usp_ValidateMaterialCart
 Created Usp_ValidateMaterialCart
procedure.
10
 Procedure
 Usp_Delete_InvalidOrder
 Created Usp_Delete_InvalidOrder
procedure.
11
 Procedure
 Usp_DeleteInvalidMaterialsInOrder
 Created Usp_DeleteInvalidMaterialsInOrder
procedure.
12
 Procedure
 Usp_DeleteinvalidAndConfirmOrder
 Created Usp_DeleteinvalidAndConfirmOrder
procedure.
13
 Table
 tblCustCollection
 Created tblCustCollection
table.
14
 Table
 tblCustSegmentation
 Created tblCustSegmentation
table.
15
 Table
 tblcustomermst
 Altered tblcustomermst
table.
16
 Page
 CreateOrder.aspx
 Implemented customer segmentation functionality.
17
 Page
 ManageOrder.aspx
 Implemented customer segmentation functionality for complete button and duplicate button.
18
 Page
 RocLogin.aspx
 Log in user value is saved on session variable.


Test Notes

ROCET_Customer Segmentation test cases -.xlsx

Reference Document (Specifications or Production Support Break Fix)

2013-04-09- 5956 -Spec- ROC- Enhancements-Customer Segmentation.pdf